<%-- 
    Document   : viewstudentlist
    Created on : Apr 12, 2012, 1:54:47 PM
    Author     : project
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
    "http://www.w3.org/TR/html4/loose.dtd">

<%@page import="java.sql.*"%>
<%@page import="jobportal.Dbconn" %>
<%@include file="header.jsp" %>
<%try {
                Connection con = Dbconn.getConn();
                String jobid = "";
                jobid = request.getParameter("jobid");
                Statement st = con.createStatement();
                String sql = "select username,name,dob,contact,email from student  where clgid='" + session.getAttribute("username") + "' and status='Verified'";
                //out.println(sql);
                ResultSet rs = st.executeQuery(sql);
%>


<table width="100%" border="0" cellpadding="0" cellspacing="0">
    <tr>
        <td align="left" valign="top">

            <span class='messagesred' style="text-align:center">
            </span>

            <table width="100%" border="0" cellspacing="0" >
                <tr>
                    <td width="100%" align="left" valign="top"><span class="mainheading_emp" style="margin-bottom:10px;"> List of Candidates</span></td>
              </tr>
                <tr>
                    <td height="10" align="left" valign="top" class="normal"></td>
                </tr>
                <tr>
                    <td height="26" align="left" valign="top" class="normal">
                        <table width="100%" border="0" cellspacing="2"  class="tbl_bdr">
                            <tr class="sde_mnu_hdr_blue">
                                <td width="26" align="left" valign="middle"><img style="margin-top:-5px; margin-left:-5px;" src="../images/top_left.gif";/></td>
                                <td colspan="7"></td>
                            </tr>
                            <tr align="center" style="color:#000066;font-weight:bold">
                                <td height="34" ></td>
                                <td style="background-color: skyblue" width="32">#</td>
                                <td width="75" align="left" valign="middle" class="subjeading" style="background-color: skyblue">Photo</td>
                                <td width="222" align="left" valign="middle" class="subjeading" style="background-color: skyblue"> Name</td>
                                <td width="129" align="left" valign="middle" class="subjeading" style="background-color: skyblue">dob</td>
                                <td width="144" align="left" valign="middle" class="subjeading" style="background-color: skyblue">contact</td>
                                <td width="160" align="left" valign="middle" class="subjeading" style="background-color: skyblue">email </td>


                                <td width="199" align="left" valign="middle" class="subjeading" style="background-color: skyblue">Action</td>
                            </tr>

                            <%
                                int i=0;
                                while (rs.next()) { i++;
                            %>
                            <tr  valign="middle">
                                <td height="94">&nbsp;</td>
                              <td align="center" width="32"><%=i%></td>
                                <td align="left" ><img src="../src/getpic.jsp?id=<%=rs.getString("username")%>&table=student&col=photo&pk_col=username" width="74" height="80"></td>
                                <td align="left" ><%= rs.getString("name")%></td>
                                <td align="left" ><%=rs.getString("dob")%></td>
                                <td align="left" ><%=rs.getString("contact")%></td>
                                <td align="left" ><%= rs.getString("email")%>          </td>

                                <td align="left" >

                                    <a href="myresumes.jsp?username=<%=rs.getString("username")%>" title="View Student Profile"><input id="submit" name="submit" type="submit" value="View Profile" class="button2" style="width:100px; height:20px;"></a>
                                </td>
                            </tr>
                            <%}%>
							<tr align="center" >
                                <td height="31" ></td>
                                <td style="background-color: skyblue" width="32">&nbsp;</td>
                                <td width="75" align="left" valign="middle" class="subjeading" style="background-color: skyblue"></td>
                                <td width="222" align="left" valign="middle" class="subjeading" style="background-color: skyblue"></td>
                                <td width="129" align="left" valign="middle" class="subjeading" style="background-color: skyblue"></td>
                                <td width="144" align="left" valign="middle" class="subjeading" style="background-color: skyblue"></td>
                                <td width="160" align="left" valign="middle" class="subjeading" style="background-color: skyblue"></td>


                                <td width="199" align="left" valign="middle" class="subjeading" style="background-color: skyblue"></td>
                            </tr>
                        </table></td>
                </tr>
            </table></td>
    </tr>
</table>
<%} catch (Exception e) {
                out.println("<font color=\"black\">" + e + "</font>");
            }%>
<a href="http://apycom.com/"></a>